{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.SUPPLEMENTARY ANALYSIS #0.11-07-2020.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 7 Nov 2020, 20:17:36
{txt}
{com}. 
. 
. 
. **** ACCESS DATABASE ***
. 
. use "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.MANUSCRIPT MODELS.11-06-2020.dta", replace
{txt}
{com}. 
. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. *** CREATE THE EFFECTIVE SAMPLE FROM THE REGRESSION MODELS ESTIMATED IN THE MANUSCRIPT ***
. 
. quietly xtrifreg fed_funding   zpolicy2_abszero  zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof nongov_recip  ///
> zloyalty2_abszero  electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
> ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
> year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
> fe i(subagency) q(05)
{txt}
{com}. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
. *** SUPPLEMENTARY ANALYSES INVOLVING BIVARIATE LINEAR PREDICTION FIT WITH 95% CONFIDENCE INTERVALS: AGGREGATE EFFECTIVE SAMPLE & ///
> *** DISAGGREGATED BY LARGE, MEDIUM, AND SMALL CA AGENCY PORTFOLIOS *** 
. 
. *** FIRST, CREATE MEASURES FOR EACH AGENCY PORTFOLIO SIZE GROUPING ***
. 
. *** LARGE CA PORTFOLIO AGENCIES: 22,575 =< X =< 61,960 (SUBAGENCY==1;==13;==24): TOTAL: 130,359 (53.93% OF EFFECTIVE SAMPLE OF 241,730) 
. 
. tab lgagencyportfolio subagency if e(sample)

{txt}lgagencypo {c |}                                                subagency code
   rtfolio {c |}         1          2          3          4          5          6          7          8          9         11 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}         0     12,608        897     11,692      1,738        723      2,448     17,080     14,009        779 {txt}{c |}{res}   111,371 
{txt}         1 {c |}{res}    45,824          0          0          0          0          0          0          0          0          0 {txt}{c |}{res}   130,359 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}    45,824     12,608        897     11,692      1,738        723      2,448     17,080     14,009        779 {txt}{c |}{res}   241,730 


{txt}lgagencypo {c |}                                                subagency code
   rtfolio {c |}        12         13         14         15         16         17         18         21         22         24 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}        16          0      7,601      3,038         53          7         69      4,543     12,663          0 {txt}{c |}{res}   111,371 
{txt}         1 {c |}{res}         0     61,960          0          0          0          0          0          0          0     22,575 {txt}{c |}{res}   130,359 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}        16     61,960      7,601      3,038         53          7         69      4,543     12,663     22,575 {txt}{c |}{res}   241,730 


{txt}lgagencypo {c |}                                                subagency code
   rtfolio {c |}        25         26         28         45         55         56         57         59         60         63 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}     1,885        108         15        946      2,736          1          1      3,606      8,223        532 {txt}{c |}{res}   111,371 
{txt}         1 {c |}{res}         0          0          0          0          0          0          0          0          0          0 {txt}{c |}{res}   130,359 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}     1,885        108         15        946      2,736          1          1      3,606      8,223        532 {txt}{c |}{res}   241,730 


           {txt}{c |} subagency
lgagencypo {c |}    code
   rtfolio {c |}        71 {c |}     Total
{hline 11}{c +}{hline 11}{c +}{hline 10}
         0 {c |}{res}     3,354 {txt}{c |}{res}   111,371 
{txt}         1 {c |}{res}         0 {txt}{c |}{res}   130,359 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
     Total {c |}{res}     3,354 {txt}{c |}{res}   241,730 
{txt}
{com}. *
. tab lgagencyportfolio  if e(sample) 

{txt}lgagencypor {c |}
     tfolio {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    111,371       46.07       46.07
{txt}          1 {c |}{res}    130,359       53.93      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. *
. *
. *** MODERATE CA PORTFOLIO AGENCIES: 11,692 =< X =< 17,080 (SUBAGENCY==2;==4;==8;==9;==2): TOTAL: 68,052 (28.15% OF EFFECTIVE SAMPLE OF 241,730)
. 
. gen medagencyportfolio = 1 if lgmedagencyportfolio==1 & lgagencyportfolio==0
{txt}(287,679 missing values generated)

{com}. replace medagencyportfolio = 0 if  medagencyportfolio==.
{txt}(287,679 real changes made)

{com}. *
. tab medagencyportfolio subagency if e(sample)

{txt}medagencyp {c |}                                                subagency code
  ortfolio {c |}         1          2          3          4          5          6          7          8          9         11 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}    45,824          0        897          0      1,738        723      2,448          0          0        779 {txt}{c |}{res}   173,678 
{txt}         1 {c |}{res}         0     12,608          0     11,692          0          0          0     17,080     14,009          0 {txt}{c |}{res}    68,052 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}    45,824     12,608        897     11,692      1,738        723      2,448     17,080     14,009        779 {txt}{c |}{res}   241,730 


{txt}medagencyp {c |}                                                subagency code
  ortfolio {c |}        12         13         14         15         16         17         18         21         22         24 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}        16     61,960      7,601      3,038         53          7         69      4,543          0     22,575 {txt}{c |}{res}   173,678 
{txt}         1 {c |}{res}         0          0          0          0          0          0          0          0     12,663          0 {txt}{c |}{res}    68,052 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}        16     61,960      7,601      3,038         53          7         69      4,543     12,663     22,575 {txt}{c |}{res}   241,730 


{txt}medagencyp {c |}                                                subagency code
  ortfolio {c |}        25         26         28         45         55         56         57         59         60         63 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}     1,885        108         15        946      2,736          1          1      3,606      8,223        532 {txt}{c |}{res}   173,678 
{txt}         1 {c |}{res}         0          0          0          0          0          0          0          0          0          0 {txt}{c |}{res}    68,052 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}     1,885        108         15        946      2,736          1          1      3,606      8,223        532 {txt}{c |}{res}   241,730 


           {txt}{c |} subagency
medagencyp {c |}    code
  ortfolio {c |}        71 {c |}     Total
{hline 11}{c +}{hline 11}{c +}{hline 10}
         0 {c |}{res}     3,354 {txt}{c |}{res}   173,678 
{txt}         1 {c |}{res}         0 {txt}{c |}{res}    68,052 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
     Total {c |}{res}     3,354 {txt}{c |}{res}   241,730 
{txt}
{com}. *
. tab medagencyportfolio  if e(sample) 

{txt}medagencypo {c |}
    rtfolio {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    173,678       71.85       71.85
{txt}          1 {c |}{res}     68,052       28.15      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. *
. *
. 
. *** SMALL CA PORTFOLIO AGENCIES: 11,692 =< X =< 17,080 (SUBAGENCY==3;==5;==7;==11;==12;==14;==15;==16;==17;==18;==21;==25;==26;==28;==45;==55;==56;==57;==59;==60;==63;==71): ///
> *** TOTAL: 43,319 (17.92% OF EFFECTIVE SAMPLE OF 241,730)
. 
. gen smagencyportfolio = 1 if lgmedagencyportfolio==0
{txt}(230,080 missing values generated)

{com}. replace smagencyportfolio = 0 if  smagencyportfolio==.
{txt}(230,080 real changes made)

{com}. *
. tab smagencyportfolio subagency if e(sample)

{txt}smagencypo {c |}                                                subagency code
   rtfolio {c |}         1          2          3          4          5          6          7          8          9         11 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}    45,824     12,608          0     11,692          0          0          0     17,080     14,009          0 {txt}{c |}{res}   198,411 
{txt}         1 {c |}{res}         0          0        897          0      1,738        723      2,448          0          0        779 {txt}{c |}{res}    43,319 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}    45,824     12,608        897     11,692      1,738        723      2,448     17,080     14,009        779 {txt}{c |}{res}   241,730 


{txt}smagencypo {c |}                                                subagency code
   rtfolio {c |}        12         13         14         15         16         17         18         21         22         24 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}         0     61,960          0          0          0          0          0          0     12,663     22,575 {txt}{c |}{res}   198,411 
{txt}         1 {c |}{res}        16          0      7,601      3,038         53          7         69      4,543          0          0 {txt}{c |}{res}    43,319 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}        16     61,960      7,601      3,038         53          7         69      4,543     12,663     22,575 {txt}{c |}{res}   241,730 


{txt}smagencypo {c |}                                                subagency code
   rtfolio {c |}        25         26         28         45         55         56         57         59         60         63 {c |}     Total
{hline 11}{c +}{hline 110}{c +}{hline 10}
         0 {c |}{res}         0          0          0          0          0          0          0          0          0          0 {txt}{c |}{res}   198,411 
{txt}         1 {c |}{res}     1,885        108         15        946      2,736          1          1      3,606      8,223        532 {txt}{c |}{res}    43,319 
{txt}{hline 11}{c +}{hline 110}{c +}{hline 10}
     Total {c |}{res}     1,885        108         15        946      2,736          1          1      3,606      8,223        532 {txt}{c |}{res}   241,730 


           {txt}{c |} subagency
smagencypo {c |}    code
   rtfolio {c |}        71 {c |}     Total
{hline 11}{c +}{hline 11}{c +}{hline 10}
         0 {c |}{res}         0 {txt}{c |}{res}   198,411 
{txt}         1 {c |}{res}     3,354 {txt}{c |}{res}    43,319 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
     Total {c |}{res}     3,354 {txt}{c |}{res}   241,730 
{txt}
{com}. *
. tab smagencyportfolio  if e(sample) 

{txt}smagencypor {c |}
     tfolio {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    198,411       82.08       82.08
{txt}          1 {c |}{res}     43,319       17.92      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. *
. *
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
. **** BIVARIATE LINEAR PREDICTION PLOTS BY AGENCY CA PORTFOLIO SIZE GROUPINGS BY DIFFERENT CA PARTNER ORGANIZATIONS [LOGGED CA AWARD SIZE DUE TO SKEW OF CA AWARD VALUES & COMPARABILITY ACROSS GRAPHS] ***
. 
. 
. *** TOTAL EFFECTIVE SAMPLE [N = 241,730]
. 
. twoway  (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & lgagencyportfolio==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & medagencyportfolio==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & smagencyportfolio==1)
{res}{txt}
{com}. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
. *** GOVERNMENTAL PARTNER ORGANIZATIONS [N = 151,851: 62.82% of TOTAL EFFECTIVE SAMPLE]; [LARGE CA AGENCIES: N = 75,777: 31.35% of OF TOTAL EFFECTIVE SAMPLE] ///
> *** [MODERATE CA AGENCIES: N = 46,816: 19.37% of OF TOTAL EFFECTIVE SAMPLE]; [SMALL CA AGENCIES: N = 29,258: 12.10% of OF TOTAL EFFECTIVE SAMPLE]
. 
. twoway  (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & lgagencyportfolio==1 & gov_recip==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & medagencyportfolio==1 & gov_recip==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & smagencyportfolio==1 & gov_recip==1)
{res}{txt}
{com}. 
. 
. 
. *** NON-GOVERNMENTAL PARTNER ORGANIZATIONS [N = 89,879: 37.18% of TOTAL EFFECTIVE SAMPLE]; [LARGE CA AGENCIES: N = 54,582: 22.58% of OF TOTAL EFFECTIVE SAMPLE] ///
> *** [MODERATE CA AGENCIES: N = 21,236: 8.79% of OF TOTAL EFFECTIVE SAMPLE]; [SMALL CA AGENCIES: N = 14,061: 5.82% of OF TOTAL EFFECTIVE SAMPLE]
. 
. twoway  (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & lgagencyportfolio==1 & gov_recip==0) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & medagencyportfolio==1 & gov_recip==0) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & smagencyportfolio==1 & gov_recip==0)
{res}{txt}
{com}. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
. *** NONPROFIT NON-GOVERNMENTAL PARTNER ORGANIZATIONS [N = 44,333: 18.34% of TOTAL EFFECTIVE SAMPLE]; [LARGE CA AGENCIES: N = 29,100: 12.04% of OF TOTAL EFFECTIVE SAMPLE] ///
> *** [MODERATE CA AGENCIES: N = 8,983: 3.72% of OF TOTAL EFFECTIVE SAMPLE]; [SMALL CA AGENCIES: N = 6,250: 2.59% of OF TOTAL EFFECTIVE SAMPLE]
. 
. twoway  (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & lgagencyportfolio==1 & nonprofit_recip==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & medagencyportfolio==1 & nonprofit_recip==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & smagencyportfolio==1 & nonprofit_recip==1)
{res}{txt}
{com}. 
. 
. 
. *** PRIVATE SECTOR NON-GOVERNMENTAL PARTNER ORGANIZATIONS [N = 45,546: 18.84% of TOTAL EFFECTIVE SAMPLE]; [LARGE CA AGENCIES: N = 25,482: 10.54% of OF TOTAL EFFECTIVE SAMPLE] ///
> *** [MODERATE CA AGENCIES: N = 12,253: 5.07% of OF TOTAL EFFECTIVE SAMPLE]; [SMALL CA AGENCIES: N = 7,811: 3.23% of OF TOTAL EFFECTIVE SAMPLE]
. 
. twoway  (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & lgagencyportfolio==1 & private_recip==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & medagencyportfolio==1 & private_recip==1) (lfitci ln_fed_funding zpolicy2_abszero if e(sample) & smagencyportfolio==1 & private_recip==1)
{res}{txt}
{com}. 
. 
. *** notes on graphics code format for graphs made above. (1) Label Legends "Large CA Portfolio Agencies"; "Medium CA Portfolio Agencies"; & "Small CA Portfolio Agencies" ///
> *** (2) Label Y-Axis "Natural Logarithm of CA Award"; (3) Label X-Axis "Agency Head Policy Expertise"; (4) Title Heading "Figure SI-0A".... "Figure SI-OE [five graphs]; ///
. *** (5) Subtitle Heading "Full Sample", "Government Organizations", "Non-Government Organizations", "Nonprofit Organizations", and "Private Organizations"; ///
> *** (6) Save each graphics file   
. 
. 
. 
. 
. 
. **** ACCESS DATABASE ***
. 
. save "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.SUPPLEMENTARY ANALYSIS #0.11-07-2020.dta", replace
{txt}(note: file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.SUPPLEMENTARY ANALYSIS #0.11-07-2020.dta not found)
file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.SUPPLEMENTARY ANALYSIS #0.11-07-2020.dta saved

{com}. 
. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.SUPPLEMENTARY ANALYSIS #0.11-07-2020.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 7 Nov 2020, 20:18:15
{txt}{.-}
{smcl}
{txt}{sf}{ul off}